USE [TOTEM]
GO

/****** Object:  StoredProcedure [dbo].[SelectIdErs]    Script Date: 05/29/2012 15:08:29 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[SelectIdErs] (@CODIGO VARCHAR(50)) AS

BEGIN

SET NOCOUNT ON;


SELECT ID_ERS FROM ERS WHERE COD_ERS=@CODIGO;



END


GO

